package com.uxhao.educenter.mapper;

import com.uxhao.educenter.entity.UcenterMember;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.uxhao.educenter.entity.dashboard.DayDataVo;

import java.util.List;

/**
 * <p>
 * 会员表 Mapper 接口
 * </p>
 *
 * @author uxhao
 * @since 2022/01/19
 */
public interface UcenterMemberMapper extends BaseMapper<UcenterMember> {

    /**
     * sql查询注册人数
     *
     * @param day
     * @return
     */
    Integer selectRegisterCount(String day);

    /**
     * Sql查询总的注册人数
     *
     * @return
     * @Date 3/4/2022
     */
    Integer selectAllRegisterCount();

    /**
     * @Description: 查询上周每日会员注册情况
     * @date 2022-04-04 16:54:44
     * @return:
     */
    List<DayDataVo> countLastWeekRegister();

    /**
     * @Description: 查询本周每日会员注册情况
     * @date 2022-04-04 16:56:31
     * @return:
     */
    List<DayDataVo> countCurrentWeekRegister();
}
